Math & Trig Functions

These functions are used for advanced mathematical operations like rounding, ranking, analysing trends and to calculate probabilities and logarithms

  • Family: PQL
  • Library: Spreadsheet
  • ◉ This function can be used with the Solve plug-in

    • Function List

    ABS

    ◉

    ACOS

    ◉

    ACOSH

    ◉

    ACOT

    ◉

    ACOTH

    ◉

    AGGREGATE

    ARABIC

    ASIN

    ◉

    ASINH

    ◉

    ATAN

    ◉

    ATAN2

    ◉

    ATANH

    ◉

    BASE

    ◉

    CEILING

    ◉

    CEILING.MATH

    ◉

    CEILING.PRECISE

    ◉

    COMBIN

    ◉

    COMBINA

    ◉

    COS

    ◉

    COSH

    ◉

    COT

    ◉

    COTH

    ◉

    CSC

    ◉

    CSCH

    ◉

    DECIMAL

    ◉

    DEGREES

    ◉

    EVEN

    ◉

    EXP

    ◉

    FACT

    ◉

    FACTDOUBLE

    ◉

    FLOOR.MATH

    ◉

    FLOOR.PRECISE

    ◉

    GCD

    ◉

    INT

    ◉

    ISO.CEILING

    LCM

    ◉

    LN

    ◉

    LOG

    ◉

    LOG10

    ◉

    MDETERM

    ◉

    MINVERSE

    ◉

    MMULT

    ◉

    MOD

    ◉

    MROUND

    ◉

    MULTINOMIAL

    ◉

    ODD

    ◉

    PI

    ◉

    POWER

    ◉

    PRODUCT

    ◉

    QUOTIENT

    ◉

    RADIANS

    ◉

    RAND

    ◉

    RANDARRAY

    RANDBETWEEN

    ◉

    ROMAN

    ROUND

    ◉

    ROUNDDOWN

    ◉

    ROUNDUP

    ◉

    SEC

    ◉

    SECH

    ◉

    SEQUENCE

    SERIESSUM

    ◉

    SIGN

    ◉

    SIN

    ◉

    SINH

    ◉

    SQRT

    ◉

    SQRTPI

    ◉

    SUBTOTAL

    SUM

    ◉

    SUMIF

    ◉

    SUMIFS

    ◉

    SUMPRODUCT

    ◉

    SUMSQ

    ◉

    SUMX2MY2

    ◉

    SUMX2PY2

    ◉

    SUMXMY2

    ◉

    TAN

    ◉

    TANH

    ◉

    TRUNC

    ◉